COMPX223-22A (HAM)

Database Practice and Experience

15 Points

Edit Header Content
Division of Health Engineering Computing & Science
School of Computing and Mathematical Sciences
Department of Computer Science

Staff

Edit Staff Content

Convenor(s)

Shaoqun Wu

Shaoqun Wu
4782
G.2.21
See Moodle
shaoqun.wu@waikato.ac.nz

Lecturer(s)

Colin Pilbrow

Colin Pilbrow
9584
G.1.11
See Moodle
colin.pilbrow@waikato.ac.nz

Administrator(s)

: maria.admiraal@waikato.ac.nz
: buddhika.subasinghe@waikato.ac.nz

Placement/WIL Coordinator(s)

Tutor(s)

: nilesh.kanji@waikato.ac.nz

Student Representative(s)

Lab Technician(s)

Librarian(s)

: alistair.lamb@waikato.ac.nz

You can contact staff by:

  • Calling +64 7 838 4466 select option 1, then enter the extension.
  • Extensions starting with 4, 5, 9 or 3 can also be direct dialled:
    • For extensions starting with 4: dial +64 7 838 extension.
    • For extensions starting with 5: dial +64 7 858 extension.
    • For extensions starting with 9: dial +64 7 837 extension.
    • For extensions starting with 3: dial +64 7 2620 + the last 3 digits of the extension e.g. 3123 = +64 7 262 0123.
Edit Staff Content

Paper Description

Edit Paper Description Content

This paper approaches the subject of databases from a practical perspective - how do I create a database and how do I retrieve/update data. Both aspects are heavily addressed in this paper. Database creation and querying, using SQL, will be introduced in lectures as you will master practical skills associated with a commercial Database product (Microsoft SQL Server). The paper also introduces Microsoft's extension to SQL, Transact-SQL, which provides a user interface to SQL Server. This is to promote both understanding and practice of the different tools used to build, access and maintain a database within a Client/Server database computing environment.

The learning outcomes for this paper are linked to Washington Accord graduate attributes WA1-WA11. Explanation of the graduate attributes can be found at: https://www.ieagreements.org/

Edit Paper Description Content

Paper Structure

Edit Paper Structure Content

The objective of this paper is to provide students with the knowledge and experience of a modern corporate relational database system. The paper will emphasise practical skills learned from a series of laboratory exercises.

Topics covered in both the laboratory and lecture programme will include:

  • Data, Databases and DBMS
  • Database Design
  • Data Definition (SQL)
  • Data Retrieval (SQL)
  • Data Modification (SQL)
  • Views
  • Triggers and Integrity Constraints
  • Security
Edit Paper Structure Content

Learning Outcomes

Edit Learning Outcomes Content

Students who successfully complete the paper should be able to:

  • design relational databases using the entity-relationship modelling method (WA1, WA2, WA3)

    Linked to the following assessments:

    • Practical Test 1
    • Practical Exercises / Moodle Quiz
    • Project Deliverable 1
    Linked to the following assessments:
  • create relational databases using SQL (WA5)

    Linked to the following assessments:

    • Practical Test 1
    • Practical Exercises / Moodle Quiz
    • Project Deliverable 2
    Linked to the following assessments:
  • query relational databases using the query language SQL (WA4)

    Linked to the following assessments:

    • Practical Test 2
    • Practical Test 3
    • Practical Exercises / Moodle Quiz
    • Project Deliverable 2
    • Project Deliverable 3
    Linked to the following assessments:
  • demonstrate their understanding of database concepts through the creation of practical database solutions (WA1, WA2, WA3)

    Linked to the following assessments:

    • Project Deliverable 1
    • Project Deliverable 2
    • Project Deliverable 3
    • Practical Exercises / Moodle Quiz
    Linked to the following assessments:
  • utilise SQL tools such as stored procedures, triggers and views (WA5)

    Linked to the following assessments:

    • Practical Test 3
    • Practical Exercises / Moodle Quiz
    • Project Deliverable 3
    Linked to the following assessments:
Edit Learning Outcomes Content
Edit Learning Outcomes Content

Assessment

Edit Assessments Content

The student must get at least 50% in two of the three tests, as well as 50% or more in the project, and must also achieve an overall mark of 50% or more to receive a passing grade for this paper.

Marks for completed work will be posted on Moodle for you to check and ensure that they have been recorded correctly. If there is any discrepancy in your marks, inform the tutor coordinator.

Ensure you keep all complete coursework until you have received your final grade. The completed coursework will be required if you need to have your grade reviewed.

If you are enrolled on a BE(Hons), samples of your work may be required as part of the Engineering New Zealand accreditation process for BE(Hons) degrees. Any samples taken will have the student name and ID redacted. If you do not want samples of your work collected then please email the engineering administrator, Natalie Shaw (natalie.shaw@waikato.ac.nz), to opt out.

Edit Additional Assessment Information Content

Assessment Components

Edit Assessments Content

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0. There is no final exam. The final exam makes up 0% of the overall mark.

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0 or 0:0, whichever is more favourable for the student. The final exam makes up either 0% or 0% of the overall mark.

Component DescriptionDue Date TimePercentage of overall markSubmission MethodCompulsory
1. Curriculum Quiz
11 Mar 2022
No set time
5
  • Online: Submit through Moodle
2. Practical Test 1
13 Apr 2022
No set time
15
  • Hand-in: In Lab
3. Practical Test 2
25 May 2022
No set time
20
  • Hand-in: In Lab
4. Practical Test 3
15 Jun 2022
No set time
20
  • Hand-in: In Lab
5. Project Deliverable 1
1 Apr 2022
4:00 PM
6
  • Online: Submit through Moodle
6. Project Deliverable 2
13 May 2022
4:00 PM
8
  • Online: Submit through Moodle
7. Project Deliverable 3
17 Jun 2022
No set time
16
  • Hand-in: In Lab
8. Practical Exercises / Moodle Quiz
10
  • Online: Submit through Moodle
Assessment Total:     100    
Failing to complete a compulsory assessment component of a paper will result in an IC grade
Edit Assessments Content

Required and Recommended Readings

Edit Required Readings Content

Required Readings

Edit Required Readings Content
There are no required textbooks for this paper. Reading material will be made available on Moodle.
Edit Required Readings Content

Recommended Readings

Edit Recommended Readings Content

There are no recommended textbooks for this paper. Reading material will be made available on Moodle.

A good textbook for students who are considering both database papers is

"Database Systems: The Complete Book" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom.
Edit Recommended Readings Content

Other Resources

Edit Other Resources Content

Computing Resources

Lab 3 and 4 in R Block are available for use by COMPX223A students to complete the practicals for this paper.

Lab 3 and 4 are open for class use during normal working hours. Outside of these hours, you will need authorisation for after hours access. A Cardax authorisation form can be obtained from the Computer Science administrators. You may use the facilities during the lab session you signed up for. Sessional assistants will be available to assist you. You should not log on during the times that another class is scheduled to use the laboratory even if there are machines not being used. You are advised to check the laboratory schedule posted on the laboratory door for the available times.

Edit Other Resources Content

Online Support

Edit Online Support Content
The course notes and handouts will be made available to students in electronic form through Moodle.
Edit Online Support Content

Workload

Edit Workload Content

You should plan to spend approximately 13 hours per week on this paper. The time (per week) will be divided as follows:

  • Lectures - 2 hrs/week
  • Practicals - 2 hrs/week
  • Reading - 2 hrs/week
  • Project - 2 hrs/week
  • Preparation and Revision - 5 hrs/week

This is a very rough guideline; the number of hours you spend and the way you allocate those hours will depend very much on your individual background and aptitudes.

Edit Workload Content

Linkages to Other Papers

Edit Linkages Content

Prerequisite(s)

Prerequisite papers: COMP103 or COMPX101 or ENGEN103

Corequisite(s)

Equivalent(s)

Restriction(s)

Restricted papers: COMP219

Edit Linkages Content